create external table jms_dm.dm_rabbit_person_taking_sed_sum_dt 
(
date_time     date COMMENT '业务日期' ,
user_code     string COMMENT '业务员code' ,
user_name     string COMMENT '业务员名字' ,
send_sum      bigint COMMENT '发件总量' ,
taking_sum   bigint COMMENT '揽收总量'  )
comment '兔兔来了业务员揽收派件量汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_rabbit_person_taking_sed_sum_dt'
TBLPROPERTIES (
 'discover.partitions' = 'false',
 'parquet.column.index.access' = 'true'
 );
